How to: Add more than one level of grouping in a report.
Solution:
In the Report Design view, select the 'View' menu and select 'Sorting and Grouping'. Use the 'Group Header' and 'Group Footer' property boxes for the selected field(s) in the 'Group Properties' window to add more than one level of grouping in a report.
1) If the Database window is not active, activate the Database window.
2) Click the 'Reports' tab in the Database window.
Reports tab
3) Select the desired report from the list box. (The selected report is highlighted.)
4) Click 'Design'. (The selected report appears in the Design view, and the floating Toolbox appears.)
5) Select the 'View' menu and select 'Sorting and Grouping'. (The Sorting and Grouping dialog box appears.)
Grouping dialog box
6) Click on the desired field to group in the 'Fields/Expression' box. (The Group Properties window appears at the bottom of the dialog box.)
7) Click on the 'Group Header' box. (A down arrow appears.)
8) Click down arrow. (A drop-down list appears.)
9) Select 'Yes' from the 'Group Header' drop-down list. (The selected field will be grouped in the header.)
10) Click on the 'Group Footer' box. (A down arrow appears.)
11) Click down arrow. (A drop-down list appears.)
12) Select 'Yes' from the 'Group Footer' drop-down list. (The selected field will be grouped in the Footer.)
13) Repeat steps 6) through 12) for each field to group.
14) Click on the 'X' in the upper right corner of the 'Sorting and Grouping' window to close.
15) Select the 'File' menu and select 'Save' to save the report.
